﻿CREATE TABLE [dbo].[HOADON] (
    [MaHD]      VARCHAR (10) NOT NULL,
    [MaNV]      VARCHAR (10) NULL,
    [NgayHD]    DATE         NULL,
    [ThanhTien] FLOAT (53)   NULL,
    PRIMARY KEY CLUSTERED ([MaHD] ASC),
    FOREIGN KEY ([MaNV]) REFERENCES [dbo].[NHANVIEN] ([MaNV])
);

